﻿CREATE PROCEDURE [dbo].[proc_Order_Item_GetCarts]
	(
		@Occupancy nvarchar(50)
	)
AS
	Select
		Id
		,OId
		,ProductId
		,ProductName
		,UnitPrice
		,Quantity
		,Salesman
		,SalesmanAccount
		,DepId
		,CompanyId
		,CreateDate
		,Occupancy
		,IsValid
		,Description
	From Order_Item Where Occupancy=@Occupancy Order by Id DESC
	RETURN
